I just found that image looks better with filmic blender which sample you have below. I will use it in the future projects also.
I could use less edges on the tube but it was too late to change it. 
Anyway here is the final mesh with no subdivision "on":
Shisha design
Published:

Shisha design

Published: